package com.xy.bizportdemo.database.entity;

/**
 * Created by XIAOYUAN on 2016/11/24.
 */

public class SmsDBTableConversation {
    public static final String KEY_ID = "_id";
    public static final String KEY_MSG_COUNT = "msg_count";
    public static final String KEY_LAST_MSG = "last_msg";
    public static final String KEY_NUMBER = "number";
    public static final String KEY_STATE = "state";
    public static final String KEY_LAST_DATE = "last_date";

    public static final String NAME = "tb_conversation";

    public static final String DROP_TABLE = " DROP TABLE IF EXISTS "
            + NAME;
    public static final String CREATE_TABLE = "create table  if not exists "
            + NAME +
            " ("
            + KEY_ID + " INTEGER PRIMARY KEY,"
            + KEY_MSG_COUNT + " INTEGER,"
            + KEY_LAST_MSG + " TEXT,"
            + KEY_NUMBER + " TEXT,"
            + KEY_STATE + " TEXT,"
            + KEY_LAST_DATE + " TEXT"
            + ")";
}
